package com.qf.erp_system_admin.entity;

import com.alibaba.excel.annotation.ExcelIgnore;
import com.alibaba.excel.annotation.ExcelProperty;
import com.alibaba.excel.annotation.write.style.ColumnWidth;
import com.alibaba.excel.annotation.write.style.HeadRowHeight;
import com.fasterxml.jackson.annotation.JsonFormat;
import java.util.Date;
@HeadRowHeight(20) // 指定列头行高
@ColumnWidth(20) // 指定列宽
public class Client {
    @ExcelIgnore
    private int cliId; //客户编号

    @ExcelProperty(value = "客户名称")
    private String cliKh;//客户名称

    @ExcelProperty(value = "联系人")
    private String cliName;//联系人

    @ExcelProperty(value = "联系电话")
    private int cliPhone;//联系电话

    @ExcelProperty(value = "联系地址")
    private String cliHome;//联系地址

    @ExcelProperty(value = "客户类别")
    private String cliCategory;//客户类别

    @ExcelProperty(value = "客户等级")
    private String cliGrade;//客户等级

    @ExcelProperty(value = "关联业务员" )
    private String cliSalesman;//关联业务员

    @ExcelProperty(value = "主采项目")
    private String cliProject;//主采项目

    @ExcelProperty(value = "创建时间")
    @JsonFormat(pattern = "yyyy-MM-dd")
    private Date cliTime;//创建时间

    @ExcelProperty(value = "结算方式" )
    private String cliAccounts;//结算方式

    @ExcelIgnore
    private int attr1;//预留字段
    @ExcelIgnore
    private int attr2;//预留字段
    @ExcelIgnore
    private String attr3;//预留字段
    @ExcelIgnore
    private String attr4;//预留字段

    @Override
    public String toString() {
        return "Client{" +
                "cliId=" + cliId +
                ", clikh='" + cliKh + '\'' +
                ", cliName='" + cliName + '\'' +
                ", cliPhone=" + cliPhone +
                ", cliHome='" + cliHome + '\'' +
                ", cliCategory='" + cliCategory + '\'' +
                ", cliGrade='" + cliGrade + '\'' +
                ", cliSalesman='" + cliSalesman + '\'' +
                ", cliProject='" + cliProject + '\'' +
                ", cliTime=" + cliTime +
                ", cliAccounts='" + cliAccounts + '\'' +
                ", attr1=" + attr1 +
                ", attr2=" + attr2 +
                ", attr3='" + attr3 + '\'' +
                ", attr4='" + attr4 + '\'' +
                '}';
    }

    public int getCliId() {
        return cliId;
    }

    public void setCliId(int cliId) {
        this.cliId = cliId;
    }

    public String getCliKh() {
        return cliKh;
    }

    public void setCliKh(String cliKh) {
        this.cliKh = cliKh;
    }

    public String getCliName() {
        return cliName;
    }

    public void setCliName(String cliName) {
        this.cliName = cliName;
    }

    public int getCliPhone() {
        return cliPhone;
    }

    public void setCliPhone(int cliPhone) {
        this.cliPhone = cliPhone;
    }

    public String getCliHome() {
        return cliHome;
    }

    public void setCliHome(String cliHome) {
        this.cliHome = cliHome;
    }

    public String getCliCategory() {
        return cliCategory;
    }

    public void setCliCategory(String cliCategory) {
        this.cliCategory = cliCategory;
    }

    public String getCliGrade() {
        return cliGrade;
    }

    public void setCliGrade(String cliGrade) {
        this.cliGrade = cliGrade;
    }

    public String getCliSalesman() {
        return cliSalesman;
    }

    public void setCliSalesman(String cliSalesman) {
        this.cliSalesman = cliSalesman;
    }

    public String getCliProject() {
        return cliProject;
    }

    public void setCliProject(String cliProject) {
        this.cliProject = cliProject;
    }

    public Date getCliTime() {
        return cliTime;
    }

    public void setCliTime(Date cliTime) {
        this.cliTime = cliTime;
    }

    public String getCliAccounts() {
        return cliAccounts;
    }

    public void setCliAccounts(String cliAccounts) {
        this.cliAccounts = cliAccounts;
    }

    public int getAttr1() {
        return attr1;
    }

    public void setAttr1(int attr1) {
        this.attr1 = attr1;
    }

    public int getAttr2() {
        return attr2;
    }

    public void setAttr2(int attr2) {
        this.attr2 = attr2;
    }

    public String getAttr3() {
        return attr3;
    }

    public void setAttr3(String attr3) {
        this.attr3 = attr3;
    }

    public String getAttr4() {
        return attr4;
    }

    public void setAttr4(String attr4) {
        this.attr4 = attr4;
    }
}
